FaStudentAidCashPlanHistory 
EntityType  Independent 
Logical Entity Name  FaStudentAidCashPlanHistory 
Default Table Name  FaStudentAidCashPlanHistory 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

FaStudentAidCashPlanHistory Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
FaStudentAidCashPlanHistoryId(PK)    INTEGER  NO 
 
StudentAwardId(FK)    INTEGER  NO 
 
AdEnrollId(FK)    INTEGER  NO 
 
SyStudentId(FK)    INTEGER  NO 
 
FaFundSourceId(FK)    INTEGER  NO 
 
AmountPackaged    MONEY(19, 4)  YES 
 
FirstPaymentDate    DATETIME  YES 
 
NumberPayments    TINYINT  YES 
 
PaymentAmount    MONEY(19, 4)  YES 
 
PaymentFreq    SMALLINT  YES 
 
PaymentDay    INTEGER  YES 
 
InterestRate    NUMERIC(5, 2)  YES 
 
InterestBalance    MONEY(19, 4)  YES 
 
PrincipalBalance    MONEY(19, 4)  YES 
 
Status    CHAR(1)  YES 
 
AwardYear    CHAR(10)  YES 
 
FaStudentAYId(FK)    INTEGER  YES 
 
CalculationDate    DATETIME  NO 
 
CalculatedByStaffID(FK)    INTEGER  NO 
 
Comment    NVARCHAR(max)  NO 
 
UserId(FK)    INTEGER  NO 
 
DateAdded    DATETIME  NO 
 
DateLstMod    DATETIME  NO 
 
ts    TIMESTAMP/DATE  NO 
 
PromNoteCmDocumentId    INTEGER  YES 
 
DownPayment    MONEY(19, 4)  YES 
 

FaStudentAidCashPlanHistory Keys 
Key Name  Key Type  Keys 
Nk_FaStudentAidCashPlanHistory_UserId  Inversion Entry  UserId 
Nk_FaStudentAidCashPlanHistory_CalculatedByStaffID  Inversion Entry  CalculatedByStaffID 
Nk_FaStudentAidCashPlanHistory_FaStudentAYId  Inversion Entry  FaStudentAYId 
Nk_FaStudentAidCashPlanHistory_FaFundSourceId  Inversion Entry  FaFundSourceId 
Nk_FaStudentAidCashPlanHistory_SyStudentId  Inversion Entry  SyStudentId 
Nk_FaStudentAidCashPlanHistory_AdEnrollId  Inversion Entry  AdEnrollId 
Nk_FaStudentAidCashPlanHistory_FaStudentAidId  Inversion Entry  StudentAwardId 
PK_FaStudentAidCashPlanHistory_FaStudentAidCashPlanHistoryId  PrimaryKey  FaStudentAidCashPlanHistoryId 

FaStudentAidCashPlanHistory Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        AdEnrollId  NO 
Staff  Non-Identifying  One To Zero or More        CalculatedByStaffID  NO 
FundSource  Non-Identifying  One To Zero or More        FaFundSourceId  NO 
StudentAward  Non-Identifying  One To Zero or More        StudentAwardId  NO 
StudentAcademicYear  Non-Identifying  Zero or One to Zero or More        FaStudentAYId  NO 
Student  Non-Identifying  One To Zero or More        SyStudentId  NO 
Staff  Non-Identifying  One To Zero or More        UserId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
FaSchedCashPlanHistory  Non-Identifying  One To Zero or More          NO 

FaStudentAidCashPlanHistory Check Constraints 
Check Constraint Name  CheckConstraint 

FaStudentAidCashPlanHistory Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.FaStudentAidCashPlanHistory 
NO       
Physical (Microsoft SQL Server)
dbo.FaStudentAidCashPlanHistory 
NO       

FaStudentAidCashPlanHistory Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Financial Aid 

FaStudentAidCashPlanHistory Data Movement Rules 
Name  Type  Rule Text/Value